List<!field#>Boxscore - Newspaper<!field#><!field#>2:0<!field#>SELECT p.first || " " || p.last || " " || "(" || (s.Single+s.Double+s.Triple+s.HomeRun) || "-" || (s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) || 
(CASE WHEN s.Double=1 THEN ", 2B" ELSE (CASE WHEN s.Double>1 THEN ", " || s.Double || " 2B" ELSE "" END) END) || 
(CASE WHEN s.Triple=1 THEN ", 3B" ELSE (CASE WHEN s.Triple>1 THEN ", "
|| s.Triple || " 3B" ELSE "" END) END) || 
(CASE WHEN s.HomeRun=1 THEN ", HR" ELSE (CASE WHEN s.HomeRun>1 THEN ", " || s.HomeRun || " HR" ELSE "" END) END) || 
(CASE WHEN s.RBI=1 THEN ", RBI" ELSE (CASE WHEN s.RBI>1 THEN ", " || s.RBI || " RBIs" ELSE "" END) END) || 
(CASE WHEN s.Runs=1 THEN ", Run" ELSE (CASE WHEN s.Runs>1 THEN ", " || s.Runs || " Runs" ELSE "" END) END) || ")" AS Summary FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.batted='1' AND s.GameID = '#idx#' <!field#>true<!field#>0<!field#>1<!field#>1<!field#>0<!line#>ListField<!field#>22<!field#>p.first || " " || p.last || " " || "(" || (s.Single+s.Double+s.Triple+s.HomeRun) || "-" || (s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) || 
(CASE WHEN s.Double=1 THEN ", 2B" ELSE (CASE WHEN s.Double>1 THEN ", " || s.Double || " 2B" ELSE "" END) END) || 
(CASE WHEN s.Triple=1 THEN ", 3B" ELSE (CASE WHEN s.Triple>1 THEN ", "
|| s.Triple || " 3B" ELSE "" END) END) || 
(CASE WHEN s.HomeRun=1 THEN ", HR" ELSE (CASE WHEN s.HomeRun>1 THEN ", " || s.HomeRun || " HR" ELSE "" END) END) || 
(CASE WHEN s.RBI=1 THEN ", RBI" ELSE (CASE WHEN s.RBI>1 THEN ", " || s.RBI || " RBIs" ELSE "" END) END) || 
(CASE WHEN s.Runs=1 THEN ", Run" ELSE (CASE WHEN s.Runs>1 THEN ", " || s.Runs || " Runs" ELSE "" END) END) || ")"<!field#>Summary<!field#>0<!field#>1<!field#>true<!field#>1*<!field#><!report#>